REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_slug) VALUES 
('ZA', 'South Africa', 'south-africa');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782117, 'za', 'Eastern Cape', 1, 'eastern-cape');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(451918, 782117, 'za', 'Willowvale', 1, 'willowvale'),
(451919, 782117, 'za', 'Uniondale', 1, 'uniondale'),
(451920, 782117, 'za', 'Ugie', 1, 'ugie'),
(451921, 782117, 'za', 'Tylden', 1, 'tylden'),
(451922, 782117, 'za', 'Tyeni', 1, 'tyeni'),
(451923, 782117, 'za', 'Tsomo', 1, 'tsomo'),
(451924, 782117, 'za', 'Tsolo', 1, 'tsolo'),
(451925, 782117, 'za', 'Tsitsikamma', 1, 'tsitsikamma'),
(451926, 782117, 'za', 'Tshatshu', 1, 'tshatshu'),
(451927, 782117, 'za', 'Thomas River', 1, 'thomas-river'),
(451928, 782117, 'za', 'Tarkastad', 1, 'tarkastad'),
(451929, 782117, 'za', 'Tabankulu', 1, 'tabankulu'),
(451930, 782117, 'za', 'Stormberg', 1, 'stormberg'),
(451931, 782117, 'za', 'Steytlerville', 1, 'steytlerville'),
(451932, 782117, 'za', 'Steynsburg', 1, 'steynsburg'),
(451933, 782117, 'za', 'Sterkstroom', 1, 'sterkstroom'),
(451934, 782117, 'za', 'Sithangameni', 1, 'sithangameni'),
(451935, 782117, 'za', 'Sidwadweni', 1, 'sidwadweni'),
(451936, 782117, 'za', 'Sheshegu', 1, 'sheshegu'),
(451937, 782117, 'za', 'Seymour', 1, 'seymour'),
(451938, 782117, 'za', 'Rossouw', 1, 'rossouw'),
(451939, 782117, 'za', 'Rietbron', 1, 'rietbron'),
(451940, 782117, 'za', 'Redoubt', 1, 'redoubt'),
(451941, 782117, 'za', 'Qumbu', 1, 'qumbu'),
(451942, 782117, 'za', 'Qolora', 1, 'qolora'),
(451943, 782117, 'za', 'Qitsi', 1, 'qitsi'),
(451944, 782117, 'za', 'Qamata', 1, 'qamata'),
(451945, 782117, 'za', 'Peddie', 1, 'peddie'),
(451946, 782117, 'za', 'Pearston', 1, 'pearston'),
(451947, 782117, 'za', 'Paterson', 1, 'paterson'),
(451948, 782117, 'za', 'Patensie', 1, 'patensie'),
(451949, 782117, 'za', 'Onder-Smoordrif', 1, 'onder-smoordrif'),
(451950, 782117, 'za', 'Oesterbaai', 1, 'oesterbaai'),
(451951, 782117, 'za', 'Ntsimbini', 1, 'ntsimbini'),
(451952, 782117, 'za', 'Nqamakwe', 1, 'nqamakwe'),
(451953, 782117, 'za', 'Nqadu', 1, 'nqadu'),
(451954, 782117, 'za', 'Ngwane', 1, 'ngwane'),
(451955, 782117, 'za', 'Ngqeleni', 1, 'ngqeleni'),
(451956, 782117, 'za', 'New Brighton', 1, 'new-brighton'),
(451957, 782117, 'za', 'Ncora', 1, 'ncora'),
(451958, 782117, 'za', 'Mqanduli', 1, 'mqanduli'),
(451959, 782117, 'za', 'Mount Frere', 1, 'mount-frere'),
(451960, 782117, 'za', 'Mount Ayliff', 1, 'mount-ayliff'),
(451961, 782117, 'za', 'Mncotsho', 1, 'mncotsho'),
(451962, 782117, 'za', 'Mnceba', 1, 'mnceba'),
(451963, 782117, 'za', 'Mjanyana', 1, 'mjanyana'),
(451964, 782117, 'za', 'Middleton', 1, 'middleton'),
(451965, 782117, 'za', 'Middledrift', 1, 'middledrift'),
(451966, 782117, 'za', 'Mgwalana', 1, 'mgwalana'),
(451967, 782117, 'za', 'Mgojweni', 1, 'mgojweni'),
(451968, 782117, 'za', 'Mdantsane', 1, 'mdantsane'),
(451969, 782117, 'za', 'Masincedane', 1, 'masincedane'),
(451970, 782117, 'za', 'Mahlungulu', 1, 'mahlungulu'),
(451971, 782117, 'za', 'Maclear', 1, 'maclear'),
(451972, 782117, 'za', 'Macleantown', 1, 'macleantown'),
(451973, 782117, 'za', 'Lusikisiki', 1, 'lusikisiki'),
(451974, 782117, 'za', 'Louterwater', 1, 'louterwater'),
(451975, 782117, 'za', 'Loerie', 1, 'loerie'),
(451976, 782117, 'za', 'Libode', 1, 'libode'),
(451977, 782117, 'za', 'Lanti', 1, 'lanti'),
(451978, 782117, 'za', 'Kwanyana', 1, 'kwanyana'),
(451979, 782117, 'za', 'KwaNobuhle', 1, 'kwanobuhle'),
(451980, 782117, 'za', 'Krakeelrivier', 1, 'krakeelrivier'),
(451981, 782117, 'za', 'Komga', 1, 'komga'),
(451982, 782117, 'za', 'Klipplaat', 1, 'klipplaat'),
(451983, 782117, 'za', 'Kleinpoort', 1, 'kleinpoort'),
(451984, 782117, 'za', 'King William’s Town', 1, 'king-williams-town'),
(451985, 782117, 'za', 'Kenton on Sea', 1, 'kenton-on-sea'),
(451986, 782117, 'za', 'Kentani', 1, 'kentani'),
(451987, 782117, 'za', 'Keiskammahoek', 1, 'keiskammahoek'),
(451988, 782117, 'za', 'Kei Road', 1, 'kei-road'),
(451989, 782117, 'za', 'Kareedouw', 1, 'kareedouw'),
(451990, 782117, 'za', 'Kamastone', 1, 'kamastone'),
(451991, 782117, 'za', 'Joubertina', 1, 'joubertina'),
(451992, 782117, 'za', 'Jeffreys Bay', 1, 'jeffreys-bay'),
(451993, 782117, 'za', 'Jansenville', 1, 'jansenville'),
(451994, 782117, 'za', 'Indwe', 1, 'indwe'),
(451995, 782117, 'za', 'Idutywa', 1, 'idutywa'),
(451996, 782117, 'za', 'Ida', 1, 'ida'),
(451997, 782117, 'za', 'Humansdorp', 1, 'humansdorp'),
(451998, 782117, 'za', 'Hogsback', 1, 'hogsback'),
(451999, 782117, 'za', 'Hofmeyr', 1, 'hofmeyr'),
(452000, 782117, 'za', 'Hankey', 1, 'hankey'),
(452001, 782117, 'za', 'Hamburg', 1, 'hamburg'),
(452002, 782117, 'za', 'Halseton', 1, 'halseton'),
(452003, 782117, 'za', 'Hackney', 1, 'hackney'),
(452004, 782117, 'za', 'Gonubie', 1, 'gonubie'),
(452005, 782117, 'za', 'Gelvandale', 1, 'gelvandale'),
(452006, 782117, 'za', 'Fort Murray', 1, 'fort-murray'),
(452007, 782117, 'za', 'Flagstaff', 1, 'flagstaff'),
(452008, 782117, 'za', 'Engcobo', 1, 'engcobo'),
(452009, 782117, 'za', 'Elliotdale', 1, 'elliotdale'),
(452010, 782117, 'za', 'Elliot', 1, 'elliot'),
(452011, 782117, 'za', 'Despatch', 1, 'despatch'),
(452012, 782117, 'za', 'Debe Nek', 1, 'debe-nek'),
(452013, 782117, 'za', 'Cookhouse', 1, 'cookhouse'),
(452014, 782117, 'za', 'Cofimvaba', 1, 'cofimvaba'),
(452015, 782117, 'za', 'Coega', 1, 'coega'),
(452016, 782117, 'za', 'Clarkebury', 1, 'clarkebury'),
(452017, 782117, 'za', 'Cathcart', 1, 'cathcart'),
(452018, 782117, 'za', 'Cala', 1, 'cala'),
(452019, 782117, 'za', 'Bongweni', 1, 'bongweni'),
(452020, 782117, 'za', 'Bolotwa', 1, 'bolotwa'),
(452021, 782117, 'za', 'Boesmansriviermond', 1, 'boesmansriviermond'),
(452022, 782117, 'za', 'Bizana', 1, 'bizana'),
(452023, 782117, 'za', 'Bethelsdorp', 1, 'bethelsdorp'),
(452024, 782117, 'za', 'Berlin', 1, 'berlin'),
(452025, 782117, 'za', 'Bedford', 1, 'bedford'),
(452026, 782117, 'za', 'Bathurst', 1, 'bathurst'),
(452027, 782117, 'za', 'Askeaton', 1, 'askeaton'),
(452028, 782117, 'za', 'Alicedale', 1, 'alicedale'),
(452029, 782117, 'za', 'Alexandria', 1, 'alexandria'),
(452030, 782117, 'za', 'Adendorp', 1, 'adendorp'),
(452031, 782117, 'za', 'Addo', 1, 'addo'),
(452032, 782117, 'za', 'Aberdeen', 1, 'aberdeen'),
(452033, 782117, 'za', 'Bagqozini', 1, 'bagqozini'),
(452034, 782117, 'za', 'Berlin South', 1, 'berlin-south'),
(452035, 782117, 'za', 'Boardwalk', 1, 'boardwalk'),
(452036, 782117, 'za', 'California', 1, 'california'),
(452037, 782117, 'za', 'Cape St Francis', 1, 'cape-st-francis'),
(452038, 782117, 'za', 'Cawood', 1, 'cawood'),
(452039, 782117, 'za', 'Clarendon Marine', 1, 'clarendon-marine'),
(452040, 782117, 'za', 'Colchester', 1, 'colchester'),
(452041, 782117, 'za', 'Debenek', 1, 'debenek'),
(452042, 782117, 'za', 'Dumabenshiya', 1, 'dumabenshiya'),
(452043, 782117, 'za', 'Eastern Cape', 1, 'eastern-cape'),
(452044, 782117, 'za', 'Estadeal', 1, 'estadeal'),
(452045, 782117, 'za', 'Ezibeleni', 1, 'ezibeleni'),
(452046, 782117, 'za', 'Gambleville', 1, 'gambleville'),
(452047, 782117, 'za', 'Goodwin Park', 1, 'goodwin-park'),
(452048, 782117, 'za', 'Gqebera', 1, 'gqebera'),
(452049, 782117, 'za', 'Grahamstown North', 1, 'grahamstown-north'),
(452051, 782117, 'za', 'Igoda', 1, 'igoda'),
(452052, 782117, 'za', 'Jersey Valley', 1, 'jersey-valley'),
(452053, 782117, 'za', 'Joe Slovo Camp', 1, 'joe-slovo-camp'),
(452054, 782117, 'za', 'Kadwezi', 1, 'kadwezi'),
(452055, 782117, 'za', 'Khayalethu', 1, 'khayalethu'),
(452056, 782117, 'za', 'Khayelitsha', 1, 'khayelitsha'),
(452057, 782117, 'za', 'Kommadagga', 1, 'kommadagga'),
(452058, 782117, 'za', 'Kwazakhele', 1, 'kwazakhele'),
(452059, 782117, 'za', 'Linton Grange', 1, 'linton-grange'),
(452060, 782117, 'za', 'Long Hope', 1, 'long-hope'),
(452061, 782117, 'za', 'Ludome', 1, 'ludome'),
(452062, 782117, 'za', 'Mabaleni', 1, 'mabaleni'),
(452063, 782117, 'za', 'Machibi', 1, 'machibi'),
(452064, 782117, 'za', 'Makwantini', 1, 'makwantini'),
(452065, 782117, 'za', 'Mbizana', 1, 'mbizana'),
(452066, 782117, 'za', 'Mbolompeni', 1, 'mbolompeni'),
(452067, 782117, 'za', 'Misgund', 1, 'misgund'),
(452068, 782117, 'za', 'Moffat Place', 1, 'moffat-place'),
(452069, 782117, 'za', 'Motherwell', 1, 'motherwell'),
(452070, 782117, 'za', 'Msobomvu', 1, 'msobomvu'),
(452071, 782117, 'za', 'Mthatha', 1, 'mthatha'),
(452072, 782117, 'za', 'Ndabakazi', 1, 'ndabakazi'),
(452073, 782117, 'za', 'Newton Park', 1, 'newton-park'),
(452074, 782117, 'za', 'Ngcelwane', 1, 'ngcelwane'),
(452075, 782117, 'za', 'Ngozi', 1, 'ngozi'),
(452076, 782117, 'za', 'Ngxakaza', 1, 'ngxakaza'),
(452077, 782117, 'za', 'Nomvalo', 1, 'nomvalo'),
(452078, 782117, 'za', 'Nonkululeko', 1, 'nonkululeko'),
(452079, 782117, 'za', 'Nonzwakazi', 1, 'nonzwakazi'),
(452080, 782117, 'za', 'Noupoort', 1, 'noupoort'),
(452081, 782117, 'za', 'Nqutyana', 1, 'nqutyana'),
(452082, 782117, 'za', 'Ntabankulu', 1, 'ntabankulu'),
(452083, 782117, 'za', 'Overbaakens', 1, 'overbaakens'),
(452084, 782117, 'za', 'Phantsi Kwentaba', 1, 'phantsi-kwentaba'),
(452085, 782117, 'za', 'Port St Johns', 1, 'port-st-johns'),
(452086, 782117, 'za', 'Rabula', 1, 'rabula'),
(452087, 782117, 'za', 'Saltville', 1, 'saltville'),
(452088, 782117, 'za', 'Sandringham', 1, 'sandringham'),
(452089, 782117, 'za', 'Sigingqini', 1, 'sigingqini'),
(452090, 782117, 'za', 'Siphiwo Mazwayi', 1, 'siphiwo-mazwayi'),
(452091, 782117, 'za', 'Sitofile', 1, 'sitofile'),
(452092, 782117, 'za', 'South Seas', 1, 'south-seas'),
(452093, 782117, 'za', 'St Francis Bay', 1, 'st-francis-bay'),
(452094, 782117, 'za', 'Swartkops', 1, 'swartkops'),
(452095, 782117, 'za', 'Thornhill', 1, 'thornhill'),
(452096, 782117, 'za', 'Tshabo 1', 1, 'tshabo-1'),
(452097, 782117, 'za', 'Tshabo 2', 1, 'tshabo-2'),
(452098, 782117, 'za', 'Tshabo 3', 1, 'tshabo-3'),
(452099, 782117, 'za', 'Tshonya', 1, 'tshonya'),
(452100, 782117, 'za', 'Tyoksvalley', 1, 'tyoksvalley'),
(452101, 782117, 'za', 'Vulindlela Heights', 1, 'vulindlela-heights'),
(452102, 782117, 'za', 'Vulindlelahoogte', 1, 'vulindlelahoogte'),
(452103, 782117, 'za', 'Walmer', 1, 'walmer'),
(452104, 782117, 'za', 'Witmos', 1, 'witmos'),
(452105, 782117, 'za', 'Zwide', 1, 'zwide'),
(452106, 782117, 'za', 'Willowmore', 1, 'willowmore'),
(452107, 782117, 'za', 'Dordrecht', 1, 'dordrecht'),
(452108, 782117, 'za', 'Alice', 1, 'alice'),
(452109, 782117, 'za', 'Molteno', 1, 'molteno'),
(452110, 782117, 'za', 'Kirkwood', 1, 'kirkwood'),
(452111, 782117, 'za', 'Whittlesea', 1, 'whittlesea'),
(452112, 782117, 'za', 'Adelaide', 1, 'adelaide'),
(452113, 782117, 'za', 'Somerset East', 1, 'somerset-east'),
(452114, 782117, 'za', 'Port Alfred', 1, 'port-alfred'),
(452115, 782117, 'za', 'Middelburg', 1, 'middelburg'),
(452116, 782117, 'za', 'Lady Frere', 1, 'lady-frere'),
(452117, 782117, 'za', 'Cradock', 1, 'cradock'),
(452118, 782117, 'za', 'Butterworth', 1, 'butterworth'),
(452119, 782117, 'za', 'Stutterheim', 1, 'stutterheim'),
(452120, 782117, 'za', 'Fort Beaufort', 1, 'fort-beaufort'),
(452121, 782117, 'za', 'Graaff-Reinet', 1, 'graaff-reinet'),
(452122, 782117, 'za', 'Umtata', 1, 'umtata'),
(452123, 782117, 'za', 'Grahamstown', 1, 'grahamstown'),
(452124, 782117, 'za', 'Queenstown', 1, 'queenstown'),
(452125, 782117, 'za', 'Bhisho', 1, 'bhisho'),
(452126, 782117, 'za', 'Uitenhage', 1, 'uitenhage'),
(452127, 782117, 'za', 'East London', 1, 'east-london'),
(452128, 782117, 'za', 'Port Elizabeth', 1, 'port-elizabeth');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782118, 'za', 'Free State', 1, 'free-state');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(452129, 782118, 'za', 'Witsieshoek', 1, 'witsieshoek'),
(452130, 782118, 'za', 'Wepener', 1, 'wepener'),
(452131, 782118, 'za', 'Warden', 1, 'warden'),
(452132, 782118, 'za', 'Vierfontein', 1, 'vierfontein'),
(452133, 782118, 'za', 'Verkeerdevlei', 1, 'verkeerdevlei'),
(452134, 782118, 'za', 'Tweespruit', 1, 'tweespruit'),
(452135, 782118, 'za', 'Tweeling', 1, 'tweeling'),
(452136, 782118, 'za', 'Trompsburg', 1, 'trompsburg'),
(452137, 782118, 'za', 'Thaba Phatshawa', 1, 'thaba-phatshawa'),
(452138, 782118, 'za', 'Steynsrus', 1, 'steynsrus'),
(452139, 782118, 'za', 'Springfontein', 1, 'springfontein'),
(452140, 782118, 'za', 'Steunmekaar', 1, 'steunmekaar'),
(452141, 782118, 'za', 'Smithfield', 1, 'smithfield'),
(452142, 782118, 'za', 'Rouxville', 1, 'rouxville'),
(452143, 782118, 'za', 'Rosendal', 1, 'rosendal'),
(452144, 782118, 'za', 'Reddersburg', 1, 'reddersburg'),
(452145, 782118, 'za', 'Philippolis', 1, 'philippolis'),
(452146, 782118, 'za', 'Petrus Steyn', 1, 'petrus-steyn'),
(452147, 782118, 'za', 'Petrusburg', 1, 'petrusburg'),
(452148, 782118, 'za', 'Paul Roux', 1, 'paul-roux'),
(452149, 782118, 'za', 'Palmietfontein', 1, 'palmietfontein'),
(452150, 782118, 'za', 'Oranjeville', 1, 'oranjeville'),
(452151, 782118, 'za', 'Odendaalsrus', 1, 'odendaalsrus'),
(452152, 782118, 'za', 'Marseilles', 1, 'marseilles'),
(452153, 782118, 'za', 'Luckhoff', 1, 'luckhoff'),
(452154, 782118, 'za', 'Lindley', 1, 'lindley'),
(452155, 782118, 'za', 'Koffiefontein', 1, 'koffiefontein'),
(452156, 782118, 'za', 'Kestell', 1, 'kestell'),
(452157, 782118, 'za', 'Jagersfontein', 1, 'jagersfontein'),
(452158, 782118, 'za', 'Hobhouse', 1, 'hobhouse'),
(452159, 782118, 'za', 'Hertzogville', 1, 'hertzogville'),
(452160, 782118, 'za', 'Fouriesburg', 1, 'fouriesburg'),
(452161, 782118, 'za', 'Ficksburg', 1, 'ficksburg'),
(452162, 782118, 'za', 'Fauresmith', 1, 'fauresmith'),
(452163, 782118, 'za', 'Excelsior', 1, 'excelsior'),
(452164, 782118, 'za', 'Edenville', 1, 'edenville'),
(452165, 782118, 'za', 'Edenburg', 1, 'edenburg'),
(452166, 782118, 'za', 'Dewetsdorp', 1, 'dewetsdorp'),
(452167, 782118, 'za', 'Dealesville', 1, 'dealesville'),
(452168, 782118, 'za', 'Cornelia', 1, 'cornelia'),
(452169, 782118, 'za', 'Clarens', 1, 'clarens'),
(452170, 782118, 'za', 'Bultfontein', 1, 'bultfontein'),
(452171, 782118, 'za', 'Botshabelo', 1, 'botshabelo'),
(452172, 782118, 'za', 'Bloemspruit', 1, 'bloemspruit'),
(452173, 782118, 'za', 'Bethulie', 1, 'bethulie'),
(452174, 782118, 'za', 'Arlington', 1, 'arlington'),
(452175, 782118, 'za', 'Aliwal North', 1, 'aliwal-north'),
(452177, 782118, 'za', 'Bambanani', 1, 'bambanani'),
(452178, 782118, 'za', 'Barkly East', 1, 'barkly-east'),
(452179, 782118, 'za', 'Bensonvale', 1, 'bensonvale'),
(452180, 782118, 'za', 'Blikana', 1, 'blikana'),
(452181, 782118, 'za', 'Bohlokong', 1, 'bohlokong'),
(452182, 782118, 'za', 'Burgersdorp', 1, 'burgersdorp'),
(452183, 782118, 'za', 'Colesberg', 1, 'colesberg'),
(452184, 782118, 'za', 'Coville', 1, 'coville'),
(452185, 782118, 'za', 'Dikgakeng', 1, 'dikgakeng'),
(452186, 782118, 'za', 'Diqhobong', 1, 'diqhobong'),
(452187, 782118, 'za', 'Dulcies Nek', 1, 'dulcies-nek'),
(452188, 782118, 'za', 'Falckvlei', 1, 'falckvlei'),
(452189, 782118, 'za', 'Free State', 1, 'free-state'),
(452190, 782118, 'za', 'Ga-rapulana', 1, 'ga-rapulana'),
(452191, 782118, 'za', 'Ga-sehunelo', 1, 'ga-sehunelo'),
(452192, 782118, 'za', 'Geduldpan', 1, 'geduldpan'),
(452193, 782118, 'za', 'Glen Harmony Central', 1, 'glen-harmony-central'),
(452194, 782118, 'za', 'Herschel', 1, 'herschel'),
(452195, 782118, 'za', 'Hoita', 1, 'hoita'),
(452196, 782118, 'za', 'Intabazwe', 1, 'intabazwe'),
(452197, 782118, 'za', 'Jamestown', 1, 'jamestown'),
(452198, 782118, 'za', 'Jozannashoek', 1, 'jozannashoek'),
(452199, 782118, 'za', 'Kagisanong', 1, 'kagisanong'),
(452200, 782118, 'za', 'Knapdaar', 1, 'knapdaar'),
(452201, 782118, 'za', 'Kroonpark', 1, 'kroonpark'),
(452202, 782118, 'za', 'Kwandofela', 1, 'kwandofela'),
(452203, 782118, 'za', 'Lady Grey', 1, 'lady-grey'),
(452204, 782118, 'za', 'Lengau', 1, 'lengau'),
(452205, 782118, 'za', 'Makaota', 1, 'makaota'),
(452206, 782118, 'za', 'Makhalaneng', 1, 'makhalaneng'),
(452207, 782118, 'za', 'Mangaung', 1, 'mangaung'),
(452209, 782118, 'za', 'Mavelebayi', 1, 'mavelebayi'),
(452210, 782118, 'za', 'Merafong', 1, 'merafong'),
(452211, 782118, 'za', 'Mokodumela', 1, 'mokodumela'),
(452212, 782118, 'za', 'Motsethabong', 1, 'motsethabong'),
(452213, 782118, 'za', 'Phomolong', 1, 'phomolong'),
(452214, 782118, 'za', 'Poelong', 1, 'poelong'),
(452215, 782118, 'za', 'Quimera', 1, 'quimera'),
(452216, 782118, 'za', 'Ramosili', 1, 'ramosili'),
(452217, 782118, 'za', 'Rosskent', 1, 'rosskent'),
(452218, 782118, 'za', 'Selosesha', 1, 'selosesha'),
(452219, 782118, 'za', 'Sipambo Basin', 1, 'sipambo-basin'),
(452220, 782118, 'za', 'Sterkspruit', 1, 'sterkspruit'),
(452221, 782118, 'za', 'Steynpan', 1, 'steynpan'),
(452222, 782118, 'za', 'Tele Bridge', 1, 'tele-bridge'),
(452223, 782118, 'za', 'Teresa', 1, 'teresa'),
(452224, 782118, 'za', 'Thabong East', 1, 'thabong-east'),
(452225, 782118, 'za', 'Theronville', 1, 'theronville'),
(452226, 782118, 'za', 'Tikwana', 1, 'tikwana'),
(452227, 782118, 'za', 'Tyinindini', 1, 'tyinindini'),
(452228, 782118, 'za', 'Venterstad', 1, 'venterstad'),
(452229, 782118, 'za', 'Westminster', 1, 'westminster'),
(452230, 782118, 'za', 'Wiegandia', 1, 'wiegandia'),
(452231, 782118, 'za', 'Vredefort', 1, 'vredefort'),
(452232, 782118, 'za', 'Ventersburg', 1, 'ventersburg'),
(452233, 782118, 'za', 'Marquard', 1, 'marquard'),
(452234, 782118, 'za', 'Winburg', 1, 'winburg'),
(452235, 782118, 'za', 'Villiers', 1, 'villiers'),
(452236, 782118, 'za', 'Koppies', 1, 'koppies'),
(452237, 782118, 'za', 'Brandfort', 1, 'brandfort'),
(452238, 782118, 'za', 'Clocolan', 1, 'clocolan'),
(452239, 782118, 'za', 'Deneysville', 1, 'deneysville'),
(452240, 782118, 'za', 'Zastron', 1, 'zastron'),
(452241, 782118, 'za', 'Vrede', 1, 'vrede'),
(452242, 782118, 'za', 'Reitz', 1, 'reitz'),
(452243, 782118, 'za', 'Ladybrand', 1, 'ladybrand'),
(452244, 782118, 'za', 'Hennenman', 1, 'hennenman'),
(452245, 782118, 'za', 'Allanridge', 1, 'allanridge'),
(452246, 782118, 'za', 'Theunissen', 1, 'theunissen'),
(452247, 782118, 'za', 'Harrismith', 1, 'harrismith'),
(452248, 782118, 'za', 'Frankfort', 1, 'frankfort'),
(452249, 782118, 'za', 'Thaba Nchu', 1, 'thaba-nchu'),
(452250, 782118, 'za', 'Senekal', 1, 'senekal'),
(452251, 782118, 'za', 'Wesselsbron', 1, 'wesselsbron'),
(452252, 782118, 'za', 'Viljoenskroon', 1, 'viljoenskroon'),
(452253, 782118, 'za', 'Heilbron', 1, 'heilbron'),
(452254, 782118, 'za', 'Parys', 1, 'parys'),
(452255, 782118, 'za', 'Bothaville', 1, 'bothaville'),
(452256, 782118, 'za', 'Sasolburg', 1, 'sasolburg'),
(452257, 782118, 'za', 'Bethlehem', 1, 'bethlehem'),
(452258, 782118, 'za', 'Phuthaditjhaba', 1, 'phuthaditjhaba'),
(452259, 782118, 'za', 'Kroonstad', 1, 'kroonstad'),
(452260, 782118, 'za', 'Virginia', 1, 'virginia'),
(452261, 782118, 'za', 'Welkom', 1, 'welkom'),
(452262, 782118, 'za', 'Bloemfontein', 1, 'bloemfontein');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782119, 'za', 'Gauteng', 1, 'gauteng');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(452263, 782119, 'za', 'Walkerville', 1, 'walkerville'),
(452264, 782119, 'za', 'Springs', 1, 'springs'),
(452265, 782119, 'za', 'Soshanguve', 1, 'soshanguve'),
(452266, 782119, 'za', 'Sebokeng', 1, 'sebokeng'),
(452267, 782119, 'za', 'Rosslyn', 1, 'rosslyn'),
(452268, 782119, 'za', 'Roshnee', 1, 'roshnee'),
(452269, 782119, 'za', 'Rivonia', 1, 'rivonia'),
(452270, 782119, 'za', 'Randburg', 1, 'randburg'),
(452271, 782119, 'za', 'Primrose', 1, 'primrose'),
(452272, 782119, 'za', 'Muldersdrif', 1, 'muldersdrif'),
(452273, 782119, 'za', 'Moroka', 1, 'moroka'),
(452274, 782119, 'za', 'Mohlakeng', 1, 'mohlakeng'),
(452275, 782119, 'za', 'Meyerton', 1, 'meyerton'),
(452276, 782119, 'za', 'Mamelodi', 1, 'mamelodi'),
(452277, 782119, 'za', 'Laudium', 1, 'laudium'),
(452278, 782119, 'za', 'KwaThema', 1, 'kwathema'),
(452279, 782119, 'za', 'Kromdraai', 1, 'kromdraai'),
(452280, 782119, 'za', 'Kempton Park', 1, 'kempton-park'),
(452281, 782119, 'za', 'Germiston', 1, 'germiston'),
(452282, 782119, 'za', 'Edenvale', 1, 'edenvale'),
(452283, 782119, 'za', 'Devon', 1, 'devon'),
(452284, 782119, 'za', 'De Deur', 1, 'de-deur'),
(452285, 782119, 'za', 'Bedfordview', 1, 'bedfordview'),
(452286, 782119, 'za', 'Alberton', 1, 'alberton'),
(452287, 782119, 'za', 'Pyramid', 1, 'pyramid'),
(452288, 782119, 'za', 'Akasia', 1, 'akasia'),
(452289, 782119, 'za', 'Ga-Rankuwa', 1, 'ga-rankuwa'),
(452290, 782119, 'za', 'Graceland', 1, 'graceland'),
(452291, 782119, 'za', 'Greenstone Hill', 1, 'greenstone-hill'),
(452292, 782119, 'za', 'Jukskeipark', 1, 'jukskeipark'),
(452293, 782119, 'za', 'Julies Park', 1, 'julies-park'),
(452294, 782119, 'za', 'Kagiso', 1, 'kagiso'),
(452295, 782119, 'za', 'Kempton Gate', 1, 'kempton-gate'),
(452296, 782119, 'za', 'Klopperpark', 1, 'klopperpark'),
(452297, 782119, 'za', 'Kocksvlei', 1, 'kocksvlei'),
(452298, 782119, 'za', 'Koolfontein', 1, 'koolfontein'),
(452299, 782119, 'za', 'Kragbron', 1, 'kragbron'),
(452300, 782119, 'za', 'Kruinhof', 1, 'kruinhof'),
(452301, 782119, 'za', 'Kwaxuma', 1, 'kwaxuma'),
(452302, 782119, 'za', 'Lenasia Ntn Centre', 1, 'lenasia-ntn-centre'),
(452303, 782119, 'za', 'Lindekuhle', 1, 'lindekuhle'),
(452304, 782119, 'za', 'Lynn East', 1, 'lynn-east'),
(452305, 782119, 'za', 'Mafatsana', 1, 'mafatsana'),
(452306, 782119, 'za', 'Magalies View', 1, 'magalies-view'),
(452307, 782119, 'za', 'Magalieskruin', 1, 'magalieskruin'),
(452308, 782119, 'za', 'Marlboro', 1, 'marlboro'),
(452309, 782119, 'za', 'Marshalltown', 1, 'marshalltown'),
(452310, 782119, 'za', 'Masitshaba', 1, 'masitshaba'),
(452311, 782119, 'za', 'Masoheng', 1, 'masoheng'),
(452312, 782119, 'za', 'Medunsa', 1, 'medunsa'),
(452313, 782119, 'za', 'Meldene', 1, 'meldene'),
(452314, 782119, 'za', 'Midvaal', 1, 'midvaal'),
(452315, 782119, 'za', 'Moiletswane', 1, 'moiletswane'),
(452316, 782119, 'za', 'Montanapark', 1, 'montanapark'),
(452317, 782119, 'za', 'Montpark', 1, 'montpark'),
(452318, 782119, 'za', 'Moot', 1, 'moot'),
(452319, 782119, 'za', 'Morula', 1, 'morula'),
(452320, 782119, 'za', 'Northwold', 1, 'northwold'),
(452321, 782119, 'za', 'Odin Park', 1, 'odin-park'),
(452322, 782119, 'za', 'Orange Farm', 1, 'orange-farm'),
(452323, 782119, 'za', 'Orange Grove', 1, 'orange-grove'),
(452324, 782119, 'za', 'Panfontein', 1, 'panfontein'),
(452325, 782119, 'za', 'Paulshof', 1, 'paulshof'),
(452326, 782119, 'za', 'Philip Nel Park', 1, 'philip-nel-park'),
(452327, 782119, 'za', 'Protea Gardens', 1, 'protea-gardens'),
(452328, 782119, 'za', 'Protea Glen', 1, 'protea-glen'),
(452329, 782119, 'za', 'Rabie Ridge', 1, 'rabie-ridge'),
(452330, 782119, 'za', 'Randpark Ridge', 1, 'randpark-ridge'),
(452331, 782119, 'za', 'Randvaal', 1, 'randvaal'),
(452332, 782119, 'za', 'Residensia', 1, 'residensia'),
(452333, 782119, 'za', 'Rietvallei Park', 1, 'rietvallei-park'),
(452334, 782119, 'za', 'Riversands', 1, 'riversands'),
(452335, 782119, 'za', 'Roodeplaat', 1, 'roodeplaat'),
(452336, 782119, 'za', 'Roosevelt Park', 1, 'roosevelt-park'),
(452337, 782119, 'za', 'Sasolburg', 1, 'sasolburg'),
(452338, 782119, 'za', 'Tamboville', 1, 'tamboville'),
(452339, 782119, 'za', 'Vaaldam', 1, 'vaaldam'),
(452340, 782119, 'za', 'ZZ TBA', 1, 'zz-tba'),
(452341, 782119, 'za', 'Modderfontein', 1, 'modderfontein'),
(452342, 782119, 'za', 'Sandton', 1, 'sandton'),
(452343, 782119, 'za', 'Cullinan', 1, 'cullinan'),
(452344, 782119, 'za', 'Bronkhorstspruit', 1, 'bronkhorstspruit'),
(452345, 782119, 'za', 'Heidelberg', 1, 'heidelberg'),
(452346, 782119, 'za', 'Mabopane', 1, 'mabopane'),
(452347, 782119, 'za', 'Randfontein', 1, 'randfontein'),
(452348, 782119, 'za', 'Nigel', 1, 'nigel'),
(452349, 782119, 'za', 'Westonaria', 1, 'westonaria'),
(452350, 782119, 'za', 'Midrand', 1, 'midrand'),
(452351, 782119, 'za', 'Roodepoort', 1, 'roodepoort'),
(452352, 782119, 'za', 'Centurion', 1, 'centurion'),
(452353, 782119, 'za', 'Vanderbijlpark', 1, 'vanderbijlpark'),
(452354, 782119, 'za', 'Brakpan', 1, 'brakpan'),
(452355, 782119, 'za', 'Krugersdorp', 1, 'krugersdorp'),
(452356, 782119, 'za', 'Boksburg', 1, 'boksburg'),
(452357, 782119, 'za', 'Vereeniging', 1, 'vereeniging'),
(452358, 782119, 'za', 'Tembisa', 1, 'tembisa'),
(452359, 782119, 'za', 'Benoni', 1, 'benoni'),
(452360, 782119, 'za', 'Pretoria', 1, 'pretoria'),
(452361, 782119, 'za', 'Soweto', 1, 'soweto'),
(452362, 782119, 'za', 'Johannesburg', 1, 'johannesburg');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782120, 'za', 'KwaZulu-Natal', 1, 'kwazulu-natal');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(452363, 782120, 'za', 'Winterton', 1, 'winterton'),
(452364, 782120, 'za', 'Winklespruit', 1, 'winklespruit'),
(452365, 782120, 'za', 'Westville', 1, 'westville'),
(452366, 782120, 'za', 'Westbrook', 1, 'westbrook'),
(452367, 782120, 'za', 'Wasbank', 1, 'wasbank'),
(452368, 782120, 'za', 'Wartburg', 1, 'wartburg'),
(452369, 782120, 'za', 'Verulam', 1, 'verulam'),
(452370, 782120, 'za', 'Vaalkop', 1, 'vaalkop'),
(452371, 782120, 'za', 'Uvongo Beach', 1, 'uvongo-beach'),
(452372, 782120, 'za', 'Underberg', 1, 'underberg'),
(452373, 782120, 'za', 'Umzumbe', 1, 'umzumbe'),
(452374, 782120, 'za', 'Umtentweni', 1, 'umtentweni'),
(452375, 782120, 'za', 'Umlazi', 1, 'umlazi'),
(452376, 782120, 'za', 'Umhlanga Rocks', 1, 'umhlanga-rocks'),
(452377, 782120, 'za', 'Umbumbulu', 1, 'umbumbulu'),
(452378, 782120, 'za', 'Umbogintwini', 1, 'umbogintwini'),
(452379, 782120, 'za', 'Uitval', 1, 'uitval'),
(452380, 782120, 'za', 'Ubombo', 1, 'ubombo'),
(452381, 782120, 'za', 'Tugela Ferry', 1, 'tugela-ferry'),
(452382, 782120, 'za', 'Shelly Beach', 1, 'shelly-beach'),
(452383, 782120, 'za', 'Sheffield Beach', 1, 'sheffield-beach'),
(452384, 782120, 'za', 'Shakaskraal', 1, 'shakaskraal'),
(452385, 782120, 'za', 'Salt Rock', 1, 'salt-rock'),
(452386, 782120, 'za', 'Saint Lucia Estuary', 1, 'saint-lucia-estuary'),
(452387, 782120, 'za', 'Richmond', 1, 'richmond'),
(452388, 782120, 'za', 'Queensburgh', 1, 'queensburgh'),
(452389, 782120, 'za', 'Port Edward', 1, 'port-edward'),
(452390, 782120, 'za', 'Pongola', 1, 'pongola'),
(452391, 782120, 'za', 'Pomeroy', 1, 'pomeroy'),
(452392, 782120, 'za', 'Pinetown', 1, 'pinetown'),
(452393, 782120, 'za', 'Phoenix', 1, 'phoenix'),
(452394, 782120, 'za', 'Paulpietersburg', 1, 'paulpietersburg'),
(452395, 782120, 'za', 'Ozwatini', 1, 'ozwatini'),
(452396, 782120, 'za', 'Osizweni', 1, 'osizweni'),
(452397, 782120, 'za', 'Nqutu', 1, 'nqutu'),
(452398, 782120, 'za', 'Nqabeni', 1, 'nqabeni'),
(452399, 782120, 'za', 'Nongoma', 1, 'nongoma'),
(452400, 782120, 'za', 'Nkandla', 1, 'nkandla'),
(452401, 782120, 'za', 'New Germany', 1, 'new-germany'),
(452402, 782120, 'za', 'Ndwedwe', 1, 'ndwedwe'),
(452403, 782120, 'za', 'Munster', 1, 'munster'),
(452404, 782120, 'za', 'Mtunzini', 1, 'mtunzini'),
(452405, 782120, 'za', 'Mtubatuba', 1, 'mtubatuba'),
(452406, 782120, 'za', 'Mount Edgecombe', 1, 'mount-edgecombe'),
(452407, 782120, 'za', 'Mkuze', 1, 'mkuze'),
(452408, 782120, 'za', 'Mid Illovo', 1, 'mid-illovo'),
(452409, 782120, 'za', 'Merrivale', 1, 'merrivale'),
(452410, 782120, 'za', 'Melmoth', 1, 'melmoth'),
(452411, 782120, 'za', 'Mbazwana', 1, 'mbazwana'),
(452412, 782120, 'za', 'Matatiele', 1, 'matatiele'),
(452413, 782120, 'za', 'Mariannhill', 1, 'mariannhill'),
(452414, 782120, 'za', 'Mapumulo', 1, 'mapumulo'),
(452415, 782120, 'za', 'Malvern', 1, 'malvern'),
(452416, 782120, 'za', 'Maidstone', 1, 'maidstone'),
(452417, 782120, 'za', 'Mahlabatini', 1, 'mahlabatini'),
(452418, 782120, 'za', 'Magabeni', 1, 'magabeni'),
(452419, 782120, 'za', 'Ladysmith', 1, 'ladysmith'),
(452420, 782120, 'za', 'KwaMbonambi', 1, 'kwambonambi'),
(452421, 782120, 'za', 'KwaMashu', 1, 'kwamashu'),
(452422, 782120, 'za', 'KwaCeza', 1, 'kwaceza'),
(452423, 782120, 'za', 'Kranskop', 1, 'kranskop'),
(452424, 782120, 'za', 'Kloof', 1, 'kloof'),
(452425, 782120, 'za', 'Jozini', 1, 'jozini'),
(452426, 782120, 'za', 'Izingolweni', 1, 'izingolweni'),
(452427, 782120, 'za', 'Ixopo', 1, 'ixopo'),
(452428, 782120, 'za', 'Ingwavuma', 1, 'ingwavuma'),
(452429, 782120, 'za', 'Inanda', 1, 'inanda'),
(452430, 782120, 'za', 'Impendle', 1, 'impendle'),
(452431, 782120, 'za', 'Illovo Beach', 1, 'illovo-beach'),
(452432, 782120, 'za', 'Ifafa Beach', 1, 'ifafa-beach'),
(452433, 782120, 'za', 'Hluhluwe', 1, 'hluhluwe'),
(452434, 782120, 'za', 'Hlobane', 1, 'hlobane'),
(452435, 782120, 'za', 'Hlabisa', 1, 'hlabisa'),
(452436, 782120, 'za', 'Himeville', 1, 'himeville'),
(452437, 782120, 'za', 'Hilton', 1, 'hilton'),
(452438, 782120, 'za', 'Hillcrest', 1, 'hillcrest'),
(452439, 782120, 'za', 'Highflats', 1, 'highflats'),
(452440, 782120, 'za', 'Hibberdene', 1, 'hibberdene'),
(452441, 782120, 'za', 'Harding', 1, 'harding'),
(452442, 782120, 'za', 'Hammarsdale', 1, 'hammarsdale'),
(452443, 782120, 'za', 'Golela', 1, 'golela'),
(452444, 782120, 'za', 'Gingindlovu', 1, 'gingindlovu'),
(452445, 782120, 'za', 'Gillitts', 1, 'gillitts'),
(452446, 782120, 'za', 'Estcourt', 1, 'estcourt'),
(452447, 782120, 'za', 'Emmaus', 1, 'emmaus'),
(452448, 782120, 'za', 'Elandskop', 1, 'elandskop'),
(452449, 782120, 'za', 'Edendale', 1, 'edendale'),
(452450, 782120, 'za', 'Doonside', 1, 'doonside'),
(452451, 782120, 'za', 'Donnybrook', 1, 'donnybrook'),
(452452, 782120, 'za', 'Darnall', 1, 'darnall'),
(452453, 782120, 'za', 'Dannhauser', 1, 'dannhauser'),
(452454, 782120, 'za', 'Dalton', 1, 'dalton'),
(452455, 782120, 'za', 'Creighton', 1, 'creighton'),
(452456, 782120, 'za', 'Colenso', 1, 'colenso'),
(452457, 782120, 'za', 'Cato Ridge', 1, 'cato-ridge'),
(452458, 782120, 'za', 'Bulwer', 1, 'bulwer'),
(452459, 782120, 'za', 'Bergville', 1, 'bergville'),
(452460, 782120, 'za', 'Anerley', 1, 'anerley'),
(452461, 782120, 'za', 'aMatikulu', 1, 'amatikulu'),
(452462, 782120, 'za', 'Amanzimtoti', 1, 'amanzimtoti'),
(452463, 782120, 'za', 'Ballito', 1, 'ballito'),
(452464, 782120, 'za', 'Amajuba', 1, 'amajuba'),
(452465, 782120, 'za', 'Blood River', 1, 'blood-river'),
(452466, 782120, 'za', 'Bombay Road', 1, 'bombay-road'),
(452467, 782120, 'za', 'Bothas Hill', 1, 'bothas-hill'),
(452468, 782120, 'za', 'Chatsworth', 1, 'chatsworth'),
(452469, 782120, 'za', 'Clernaville', 1, 'clernaville'),
(452470, 782120, 'za', 'Coffee Farm', 1, 'coffee-farm'),
(452471, 782120, 'za', 'Desainagar', 1, 'desainagar'),
(452472, 782120, 'za', 'Dormerton', 1, 'dormerton'),
(452473, 782120, 'za', 'Dumbe', 1, 'dumbe'),
(452474, 782120, 'za', 'Durban North', 1, 'durban-north'),
(452475, 782120, 'za', 'Emondlo', 1, 'emondlo'),
(452476, 782120, 'za', 'Emphithi', 1, 'emphithi'),
(452477, 782120, 'za', 'Eston', 1, 'eston'),
(452478, 782120, 'za', 'Ezakheni', 1, 'ezakheni'),
(452479, 782120, 'za', 'Harrismith', 1, 'harrismith'),
(452480, 782120, 'za', 'Hemuhemu', 1, 'hemuhemu'),
(452481, 782120, 'za', 'Hoha', 1, 'hoha'),
(452482, 782120, 'za', 'Imdumeni', 1, 'imdumeni'),
(452483, 782120, 'za', 'Isipingo', 1, 'isipingo'),
(452484, 782120, 'za', 'Jacobs', 1, 'jacobs'),
(452485, 782120, 'za', 'Kaarkloof', 1, 'kaarkloof'),
(452486, 782120, 'za', 'Kwadlangezwa', 1, 'kwadlangezwa'),
(452487, 782120, 'za', 'Kwamkhonto', 1, 'kwamkhonto'),
(452488, 782120, 'za', 'Kwangwanase', 1, 'kwangwanase'),
(452489, 782120, 'za', 'Kwazimele', 1, 'kwazimele'),
(452490, 782120, 'za', 'Kwazulu/Natal', 1, 'kwazulunatal'),
(452491, 782120, 'za', 'Lamontville', 1, 'lamontville'),
(452492, 782120, 'za', 'Magadla', 1, 'magadla'),
(452493, 782120, 'za', 'Maluti', 1, 'maluti'),
(452494, 782120, 'za', 'Manaba Beach', 1, 'manaba-beach'),
(452495, 782120, 'za', 'Mandeni', 1, 'mandeni'),
(452496, 782120, 'za', 'Manzana', 1, 'manzana'),
(452497, 782120, 'za', 'Marble Ray', 1, 'marble-ray'),
(452498, 782120, 'za', 'Mayville', 1, 'mayville'),
(452499, 782120, 'za', 'Mbeka', 1, 'mbeka'),
(452500, 782120, 'za', 'Mbiyo', 1, 'mbiyo'),
(452501, 782120, 'za', 'Mehlomnyama', 1, 'mehlomnyama'),
(452502, 782120, 'za', 'Mobeni', 1, 'mobeni'),
(452503, 782120, 'za', 'Mount Fletcher', 1, 'mount-fletcher'),
(452504, 782120, 'za', 'Mphophomeni', 1, 'mphophomeni'),
(452505, 782120, 'za', 'Nagina', 1, 'nagina'),
(452506, 782120, 'za', 'Ncalu', 1, 'ncalu'),
(452507, 782120, 'za', 'Ncotshane', 1, 'ncotshane'),
(452508, 782120, 'za', 'Nkumane', 1, 'nkumane'),
(452509, 782120, 'za', 'Nkwazi', 1, 'nkwazi'),
(452510, 782120, 'za', 'Northdene', 1, 'northdene'),
(452511, 782120, 'za', 'Nottingham Rd', 1, 'nottingham-rd'),
(452512, 782120, 'za', 'Ntabamhlophe', 1, 'ntabamhlophe'),
(452513, 782120, 'za', 'Ntokozweni', 1, 'ntokozweni'),
(452514, 782120, 'za', 'Pennington', 1, 'pennington'),
(452516, 782120, 'za', 'Rossburgh', 1, 'rossburgh'),
(452517, 782120, 'za', 'Shallcross', 1, 'shallcross'),
(452518, 782120, 'za', 'St Lucia Estuary', 1, 'st-lucia-estuary'),
(452519, 782120, 'za', 'St Wendolins', 1, 'st-wendolins'),
(452520, 782120, 'za', 'Steadville', 1, 'steadville'),
(452521, 782120, 'za', 'Taylors Halt', 1, 'taylors-halt'),
(452522, 782120, 'za', 'Umhlali', 1, 'umhlali'),
(452523, 782120, 'za', 'Umkomaas Valley', 1, 'umkomaas-valley'),
(452524, 782120, 'za', 'Umtata', 1, 'umtata'),
(452525, 782120, 'za', 'Umzimkhulu', 1, 'umzimkhulu'),
(452526, 782120, 'za', 'Wiggins', 1, 'wiggins'),
(452527, 782120, 'za', 'Yellowwood Park', 1, 'yellowwood-park'),
(452528, 782120, 'za', 'Zinkwazi', 1, 'zinkwazi'),
(452529, 782120, 'za', 'Utrecht', 1, 'utrecht'),
(452530, 782120, 'za', 'Mooirivier', 1, 'mooirivier'),
(452531, 782120, 'za', 'Glencoe', 1, 'glencoe'),
(452532, 782120, 'za', 'Greytown', 1, 'greytown'),
(452533, 782120, 'za', 'Ekuvukeni', 1, 'ekuvukeni'),
(452534, 782120, 'za', 'Eshowe', 1, 'eshowe'),
(452535, 782120, 'za', 'Umkomaas', 1, 'umkomaas'),
(452536, 782120, 'za', 'Ulundi', 1, 'ulundi'),
(452537, 782120, 'za', 'Scottburgh', 1, 'scottburgh'),
(452538, 782120, 'za', 'Kokstad', 1, 'kokstad'),
(452539, 782120, 'za', 'Empangeni', 1, 'empangeni'),
(452540, 782120, 'za', 'Howick', 1, 'howick'),
(452541, 782120, 'za', 'Margate', 1, 'margate'),
(452542, 782120, 'za', 'eSikhawini', 1, 'esikhawini'),
(452543, 782120, 'za', 'Port Shepstone', 1, 'port-shepstone'),
(452544, 782120, 'za', 'Stanger', 1, 'stanger'),
(452545, 782120, 'za', 'Dundee', 1, 'dundee'),
(452546, 782120, 'za', 'Vryheid', 1, 'vryheid'),
(452547, 782120, 'za', 'Richards Bay', 1, 'richards-bay'),
(452548, 782120, 'za', 'Newcastle', 1, 'newcastle'),
(452549, 782120, 'za', 'Pietermaritzburg', 1, 'pietermaritzburg'),
(452550, 782120, 'za', 'Durban', 1, 'durban');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782121, 'za', 'Limpopo', 1, 'limpopo');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(452551, 782121, 'za', 'Zebediela', 1, 'zebediela'),
(452552, 782121, 'za', 'Vaalwater', 1, 'vaalwater'),
(452553, 782121, 'za', 'Sibasa', 1, 'sibasa'),
(452554, 782121, 'za', 'Mutale', 1, 'mutale'),
(452555, 782121, 'za', 'Modjadji', 1, 'modjadji'),
(452556, 782121, 'za', 'Letaba', 1, 'letaba'),
(452557, 782121, 'za', 'Jane Furse', 1, 'jane-furse'),
(452558, 782121, 'za', 'Hoedspruit', 1, 'hoedspruit'),
(452559, 782121, 'za', 'Gravelotte', 1, 'gravelotte'),
(452560, 782121, 'za', 'Dendron', 1, 'dendron'),
(452561, 782121, 'za', 'Bochum', 1, 'bochum'),
(452562, 782121, 'za', 'Alldays', 1, 'alldays'),
(452563, 782121, 'za', 'Bela Bela', 1, 'bela-bela'),
(452564, 782121, 'za', 'Lephalale', 1, 'lephalale'),
(452565, 782121, 'za', 'Makhado', 1, 'makhado'),
(452566, 782121, 'za', 'Malamulele', 1, 'malamulele'),
(452567, 782121, 'za', 'Modimolle', 1, 'modimolle'),
(452568, 782121, 'za', 'Modjadjiskloof', 1, 'modjadjiskloof'),
(452569, 782121, 'za', 'Mokopane', 1, 'mokopane'),
(452570, 782121, 'za', 'Musina', 1, 'musina'),
(452571, 782121, 'za', 'Vuwani', 1, 'vuwani'),
(452572, 782121, 'za', 'Thabazimbi', 1, 'thabazimbi'),
(452573, 782121, 'za', 'GAKGAPANE', 1, 'gakgapane'),
(452574, 782121, 'za', 'Tzaneen', 1, 'tzaneen'),
(452575, 782121, 'za', 'Giyani', 1, 'giyani'),
(452576, 782121, 'za', 'Thohoyandou', 1, 'thohoyandou'),
(452577, 782121, 'za', 'Louis Trichardt', 1, 'louis-trichardt'),
(452578, 782121, 'za', 'Polokwane', 1, 'polokwane');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782122, 'za', 'Mpumalanga', 1, 'mpumalanga');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(452579, 782122, 'za', 'Wakkerstroom', 1, 'wakkerstroom'),
(452580, 782122, 'za', 'Steelpoort', 1, 'steelpoort'),
(452581, 782122, 'za', 'Skukuza', 1, 'skukuza'),
(452582, 782122, 'za', 'Skilpadfontein', 1, 'skilpadfontein'),
(452583, 782122, 'za', 'Shongwe Mission', 1, 'shongwe-mission'),
(452584, 782122, 'za', 'Sakhile', 1, 'sakhile'),
(452585, 782122, 'za', 'Sabie', 1, 'sabie'),
(452586, 782122, 'za', 'Rietkuil', 1, 'rietkuil'),
(452587, 782122, 'za', 'Ogies', 1, 'ogies'),
(452588, 782122, 'za', 'Nsikazi', 1, 'nsikazi'),
(452589, 782122, 'za', 'Marble Hall', 1, 'marble-hall'),
(452590, 782122, 'za', 'Malelane', 1, 'malelane'),
(452591, 782122, 'za', 'Machadodorp', 1, 'machadodorp'),
(452592, 782122, 'za', 'Leslie', 1, 'leslie'),
(452593, 782122, 'za', 'KwaLugedlane', 1, 'kwalugedlane'),
(452594, 782122, 'za', 'Hazyview', 1, 'hazyview'),
(452595, 782122, 'za', 'Groblersdal', 1, 'groblersdal'),
(452596, 782122, 'za', 'Graskop', 1, 'graskop'),
(452597, 782122, 'za', 'Evander', 1, 'evander'),
(452598, 782122, 'za', 'eNyamazaneni', 1, 'enyamazaneni'),
(452599, 782122, 'za', 'eMpumalanga', 1, 'empumalanga'),
(452600, 782122, 'za', 'Carolina', 1, 'carolina'),
(452601, 782122, 'za', 'Burgersfort', 1, 'burgersfort'),
(452602, 782122, 'za', 'Bosbokrand', 1, 'bosbokrand'),
(452603, 782122, 'za', 'Blinkpan', 1, 'blinkpan'),
(452604, 782122, 'za', 'Bethalrand', 1, 'bethalrand'),
(452605, 782122, 'za', 'Badplaas', 1, 'badplaas'),
(452606, 782122, 'za', 'Amsterdam', 1, 'amsterdam'),
(452607, 782122, 'za', 'Amersfoort', 1, 'amersfoort'),
(452608, 782122, 'za', 'Bamokgoko', 1, 'bamokgoko'),
(452609, 782122, 'za', 'Batubatse', 1, 'batubatse'),
(452610, 782122, 'za', 'Boitekong', 1, 'boitekong'),
(452611, 782122, 'za', 'Boleu', 1, 'boleu'),
(452612, 782122, 'za', 'Brits', 1, 'brits'),
(452613, 782122, 'za', 'Chromite', 1, 'chromite'),
(452614, 782122, 'za', 'Devon', 1, 'devon'),
(452615, 782122, 'za', 'Dibasabophelo', 1, 'dibasabophelo'),
(452616, 782122, 'za', 'Driekop', 1, 'driekop'),
(452617, 782122, 'za', 'Dundonald', 1, 'dundonald'),
(452618, 782122, 'za', 'Ekangala', 1, 'ekangala'),
(452619, 782122, 'za', 'Ellisras', 1, 'ellisras'),
(452620, 782122, 'za', 'Ga-rankuwa', 1, 'ga-rankuwa'),
(452621, 782122, 'za', 'Hammanskraal', 1, 'hammanskraal'),
(452622, 782122, 'za', 'Hluvukani', 1, 'hluvukani'),
(452623, 782122, 'za', 'Kabokweni', 1, 'kabokweni'),
(452624, 782122, 'za', 'Koster', 1, 'koster'),
(452625, 782122, 'za', 'Kwaguqa', 1, 'kwaguqa'),
(452626, 782122, 'za', 'Kwamhlanga', 1, 'kwamhlanga'),
(452627, 782122, 'za', 'Kwazamokuhle', 1, 'kwazamokuhle'),
(452628, 782122, 'za', 'Leeupoort', 1, 'leeupoort'),
(452629, 782122, 'za', 'Lephalale', 1, 'lephalale'),
(452630, 782122, 'za', 'Lethabong', 1, 'lethabong'),
(452631, 782122, 'za', 'Letlhabile', 1, 'letlhabile'),
(452632, 782122, 'za', 'Mabopane', 1, 'mabopane'),
(452633, 782122, 'za', 'Mafikeng', 1, 'mafikeng'),
(452634, 782122, 'za', 'Mahwelereng', 1, 'mahwelereng'),
(452635, 782122, 'za', 'Malamulele', 1, 'malamulele'),
(452636, 782122, 'za', 'Marikana', 1, 'marikana'),
(452637, 782122, 'za', 'Mbibane', 1, 'mbibane'),
(452638, 782122, 'za', 'Mkhuhlu', 1, 'mkhuhlu'),
(452639, 782122, 'za', 'Mogwase', 1, 'mogwase'),
(452640, 782122, 'za', 'Mokamole', 1, 'mokamole'),
(452641, 782122, 'za', 'Mooinooi', 1, 'mooinooi'),
(452642, 782122, 'za', 'Mphe-batho', 1, 'mphe-batho'),
(452643, 782122, 'za', 'Mpudulle', 1, 'mpudulle'),
(452644, 782122, 'za', 'Mpuluzi', 1, 'mpuluzi'),
(452645, 782122, 'za', 'Mpumalanga', 1, 'mpumalanga'),
(452646, 782122, 'za', 'Mutlestad', 1, 'mutlestad'),
(452647, 782122, 'za', 'Namakgale', 1, 'namakgale'),
(452648, 782122, 'za', 'Nasaret', 1, 'nasaret'),
(452649, 782122, 'za', 'Nebo', 1, 'nebo'),
(452650, 782122, 'za', 'Nelspruit North', 1, 'nelspruit-north'),
(452651, 782122, 'za', 'Nkwe', 1, 'nkwe'),
(452652, 782122, 'za', 'Nucam', 1, 'nucam'),
(452653, 782122, 'za', 'Nylpark', 1, 'nylpark'),
(452654, 782122, 'za', 'Odinburg', 1, 'odinburg'),
(452655, 782122, 'za', 'Penge', 1, 'penge'),
(452656, 782122, 'za', 'Podiphatshwa', 1, 'podiphatshwa'),
(452657, 782122, 'za', 'Potgietersrus', 1, 'potgietersrus'),
(452658, 782122, 'za', 'Pullens Hope', 1, 'pullens-hope'),
(452659, 782122, 'za', 'Rantebeng', 1, 'rantebeng'),
(452660, 782122, 'za', 'Rayton', 1, 'rayton'),
(452661, 782122, 'za', 'Rebone', 1, 'rebone'),
(452662, 782122, 'za', 'Regorogile', 1, 'regorogile'),
(452663, 782122, 'za', 'Roedtan', 1, 'roedtan'),
(452664, 782122, 'za', 'Rust De Winter', 1, 'rust-de-winter'),
(452665, 782122, 'za', 'Saulspoort', 1, 'saulspoort'),
(452666, 782122, 'za', 'Sekhukhune', 1, 'sekhukhune'),
(452667, 782122, 'za', 'Settlers', 1, 'settlers'),
(452668, 782122, 'za', 'Soshanguve', 1, 'soshanguve'),
(452669, 782122, 'za', 'Sundra', 1, 'sundra'),
(452670, 782122, 'za', 'Swartklip', 1, 'swartklip'),
(452671, 782122, 'za', 'Thabazimbi', 1, 'thabazimbi'),
(452672, 782122, 'za', 'Thohoyandou', 1, 'thohoyandou'),
(452673, 782122, 'za', 'Thulamahashe', 1, 'thulamahashe'),
(452674, 782122, 'za', 'Thulwe', 1, 'thulwe'),
(452675, 782122, 'za', 'Vaalwater', 1, 'vaalwater'),
(452676, 782122, 'za', 'Van Dyksdrif', 1, 'van-dyksdrif'),
(452677, 782122, 'za', 'Ximhungwe', 1, 'ximhungwe'),
(452678, 782122, 'za', 'Xipame', 1, 'xipame'),
(452679, 782122, 'za', 'ZZ TBA', 1, 'zz-tba'),
(452680, 782122, 'za', 'Belfast', 1, 'belfast'),
(452681, 782122, 'za', 'Breyten', 1, 'breyten'),
(452682, 782122, 'za', 'Kriel', 1, 'kriel'),
(452683, 782122, 'za', 'Hendrina', 1, 'hendrina'),
(452684, 782122, 'za', 'White River', 1, 'white-river'),
(452685, 782122, 'za', 'Secunda', 1, 'secunda'),
(452686, 782122, 'za', 'Komatipoort', 1, 'komatipoort'),
(452687, 782122, 'za', 'Lydenburg', 1, 'lydenburg'),
(452688, 782122, 'za', 'Siyabuswa', 1, 'siyabuswa'),
(452689, 782122, 'za', 'Ermelo', 1, 'ermelo'),
(452690, 782122, 'za', 'Volksrust', 1, 'volksrust'),
(452691, 782122, 'za', 'Balfour', 1, 'balfour'),
(452692, 782122, 'za', 'Standerton', 1, 'standerton'),
(452693, 782122, 'za', 'Piet Retief', 1, 'piet-retief'),
(452694, 782122, 'za', 'Delmas', 1, 'delmas'),
(452695, 782122, 'za', 'Nelspruit', 1, 'nelspruit'),
(452696, 782122, 'za', 'eMbalenhle', 1, 'embalenhle'),
(452697, 782122, 'za', 'Middelburg', 1, 'middelburg'),
(452698, 782122, 'za', 'Witbank', 1, 'witbank');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782123, 'za', 'North-West', 1, 'north-west');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(452699, 782123, 'za', 'Ventersdorp', 1, 'ventersdorp'),
(452700, 782123, 'za', 'Swartruggens', 1, 'swartruggens'),
(452701, 782123, 'za', 'Sannieshof', 1, 'sannieshof'),
(452702, 782123, 'za', 'Ottosdal', 1, 'ottosdal'),
(452703, 782123, 'za', 'Montshiwa', 1, 'montshiwa'),
(452704, 782123, 'za', 'Makwassie', 1, 'makwassie'),
(452705, 782123, 'za', 'Mafikeng', 1, 'mafikeng'),
(452706, 782123, 'za', 'Madikwe', 1, 'madikwe'),
(452707, 782123, 'za', 'Madibogo', 1, 'madibogo'),
(452708, 782123, 'za', 'Leeudoringstad', 1, 'leeudoringstad'),
(452709, 782123, 'za', 'Kokosi', 1, 'kokosi'),
(452710, 782123, 'za', 'Jouberton', 1, 'jouberton'),
(452711, 782123, 'za', 'Itsoseng', 1, 'itsoseng'),
(452712, 782123, 'za', 'Hartbeespoort', 1, 'hartbeespoort'),
(452713, 782123, 'za', 'Hartbeesfontein', 1, 'hartbeesfontein'),
(452714, 782123, 'za', 'Groot-Marico', 1, 'groot-marico'),
(452715, 782123, 'za', 'Delareyville', 1, 'delareyville'),
(452716, 782123, 'za', 'Coligny', 1, 'coligny'),
(452717, 782123, 'za', 'Atamelang', 1, 'atamelang'),
(452718, 782123, 'za', 'Carletonville', 1, 'carletonville'),
(452719, 782123, 'za', 'Hekpoort', 1, 'hekpoort'),
(452720, 782123, 'za', 'Lebogang', 1, 'lebogang'),
(452721, 782123, 'za', 'Lerato', 1, 'lerato'),
(452722, 782123, 'za', 'Radithuso', 1, 'radithuso'),
(452723, 782123, 'za', 'Bloemhof', 1, 'bloemhof'),
(452724, 782123, 'za', 'Christiana', 1, 'christiana'),
(452725, 782123, 'za', 'Zeerust', 1, 'zeerust'),
(452726, 782123, 'za', 'Wolmaransstad', 1, 'wolmaransstad'),
(452727, 782123, 'za', 'Fochville', 1, 'fochville'),
(452728, 782123, 'za', 'Lichtenburg', 1, 'lichtenburg'),
(452729, 782123, 'za', 'Schweizer-Reineke', 1, 'schweizer-reineke'),
(452730, 782123, 'za', 'Mmabatho', 1, 'mmabatho'),
(452731, 782123, 'za', 'Stilfontein', 1, 'stilfontein'),
(452732, 782123, 'za', 'Potchefstroom', 1, 'potchefstroom'),
(452733, 782123, 'za', 'Rustenburg', 1, 'rustenburg'),
(452734, 782123, 'za', 'Orkney', 1, 'orkney'),
(452735, 782123, 'za', 'Klerksdorp', 1, 'klerksdorp');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782124, 'za', 'Northern Cape', 1, 'northern-cape');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(452736, 782124, 'za', 'Windsorton', 1, 'windsorton'),
(452737, 782124, 'za', 'Williston', 1, 'williston'),
(452738, 782124, 'za', 'Vanderkloof', 1, 'vanderkloof'),
(452739, 782124, 'za', 'Ulco', 1, 'ulco'),
(452740, 782124, 'za', 'Sutherland', 1, 'sutherland'),
(452741, 782124, 'za', 'Strydenburg', 1, 'strydenburg'),
(452742, 782124, 'za', 'Rietfontein', 1, 'rietfontein'),
(452743, 782124, 'za', 'Postmasburg', 1, 'postmasburg'),
(452744, 782124, 'za', 'Philipstown', 1, 'philipstown'),
(452745, 782124, 'za', 'Petrusville', 1, 'petrusville'),
(452746, 782124, 'za', 'Olifantshoek', 1, 'olifantshoek'),
(452747, 782124, 'za', 'Niekerkshoop', 1, 'niekerkshoop'),
(452748, 782124, 'za', 'Marydale', 1, 'marydale'),
(452749, 782124, 'za', 'Mancorp Mine', 1, 'mancorp-mine'),
(452750, 782124, 'za', 'Lime Acres', 1, 'lime-acres'),
(452751, 782124, 'za', 'Kenhardt', 1, 'kenhardt'),
(452752, 782124, 'za', 'Keimoes', 1, 'keimoes'),
(452753, 782124, 'za', 'Kakamas', 1, 'kakamas'),
(452754, 782124, 'za', 'Hotazel', 1, 'hotazel'),
(452755, 782124, 'za', 'Hopetown', 1, 'hopetown'),
(452756, 782124, 'za', 'Hartswater', 1, 'hartswater'),
(452757, 782124, 'za', 'Grootdrink', 1, 'grootdrink'),
(452758, 782124, 'za', 'Groblershoop', 1, 'groblershoop'),
(452759, 782124, 'za', 'Griekwastad', 1, 'griekwastad'),
(452760, 782124, 'za', 'Douglas', 1, 'douglas'),
(452761, 782124, 'za', 'Dibeng', 1, 'dibeng'),
(452762, 782124, 'za', 'Delportshoop', 1, 'delportshoop'),
(452763, 782124, 'za', 'Britstown', 1, 'britstown'),
(452764, 782124, 'za', 'Brandvlei', 1, 'brandvlei'),
(452765, 782124, 'za', 'Askham', 1, 'askham'),
(452766, 782124, 'za', 'Vioolsdrif', 1, 'vioolsdrif'),
(452767, 782124, 'za', 'Steinkopf', 1, 'steinkopf'),
(452768, 782124, 'za', 'Port Nolloth', 1, 'port-nolloth'),
(452769, 782124, 'za', 'Pofadder', 1, 'pofadder'),
(452770, 782124, 'za', 'Pella', 1, 'pella'),
(452771, 782124, 'za', 'Okiep', 1, 'okiep'),
(452772, 782124, 'za', 'Nieuwoudtville', 1, 'nieuwoudtville'),
(452773, 782124, 'za', 'Nababeep', 1, 'nababeep'),
(452774, 782124, 'za', 'Loeriesfontein', 1, 'loeriesfontein'),
(452775, 782124, 'za', 'Kotzeshoop', 1, 'kotzeshoop'),
(452776, 782124, 'za', 'Kleinsee', 1, 'kleinsee'),
(452777, 782124, 'za', 'Kamieskroon', 1, 'kamieskroon'),
(452778, 782124, 'za', 'Garies', 1, 'garies'),
(452779, 782124, 'za', 'Alexander Bay', 1, 'alexander-bay'),
(452780, 782124, 'za', 'Beaconsfield', 1, 'beaconsfield'),
(452781, 782124, 'za', 'Belmont', 1, 'belmont'),
(452782, 782124, 'za', 'Boshof', 1, 'boshof'),
(452783, 782124, 'za', 'Galeshewe', 1, 'galeshewe'),
(452784, 782124, 'za', 'Ganyesa', 1, 'ganyesa'),
(452785, 782124, 'za', 'Jacobsdal', 1, 'jacobsdal'),
(452786, 782124, 'za', 'Jan Kempdorp', 1, 'jan-kempdorp'),
(452787, 782124, 'za', 'Madibogo', 1, 'madibogo'),
(452788, 782124, 'za', 'Magogong', 1, 'magogong'),
(452789, 782124, 'za', 'Mankurwane', 1, 'mankurwane'),
(452790, 782124, 'za', 'Mothibistat', 1, 'mothibistat'),
(452791, 782124, 'za', 'Northern Cape', 1, 'northern-cape'),
(452792, 782124, 'za', 'Pescodia', 1, 'pescodia'),
(452793, 782124, 'za', 'Pomfret', 1, 'pomfret'),
(452794, 782124, 'za', 'Pudimoe', 1, 'pudimoe'),
(452795, 782124, 'za', 'Reivilo', 1, 'reivilo'),
(452796, 782124, 'za', 'Seseng', 1, 'seseng'),
(452797, 782124, 'za', 'Stella', 1, 'stella'),
(452798, 782124, 'za', 'Taung', 1, 'taung'),
(452799, 782124, 'za', 'Vredendal', 1, 'vredendal'),
(452800, 782124, 'za', 'Vryburg', 1, 'vryburg'),
(452801, 782124, 'za', 'Carnarvon', 1, 'carnarvon'),
(452802, 782124, 'za', 'Calvinia', 1, 'calvinia'),
(452803, 782124, 'za', 'Kuruman', 1, 'kuruman'),
(452804, 782124, 'za', 'Kathu', 1, 'kathu'),
(452805, 782124, 'za', 'Ritchie', 1, 'ritchie'),
(452806, 782124, 'za', 'Daniëlskuil', 1, 'danielskuil'),
(452807, 782124, 'za', 'Springbok', 1, 'springbok'),
(452808, 782124, 'za', 'Prieska', 1, 'prieska'),
(452809, 782124, 'za', 'Barkly West', 1, 'barkly-west'),
(452810, 782124, 'za', 'Warrenton', 1, 'warrenton'),
(452811, 782124, 'za', 'De Aar', 1, 'de-aar'),
(452812, 782124, 'za', 'Upington', 1, 'upington'),
(452813, 782124, 'za', 'Kimberley', 1, 'kimberley');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(782125, 'za', 'Western Cape', 1, 'western-cape');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(452814, 782125, 'za', 'Wilderness', 1, 'wilderness'),
(452815, 782125, 'za', 'Touwsrivier', 1, 'touwsrivier'),
(452816, 782125, 'za', 'Stilbaai', 1, 'stilbaai'),
(452817, 782125, 'za', 'Sedgefield', 1, 'sedgefield'),
(452818, 782125, 'za', 'Riversdale', 1, 'riversdale'),
(452819, 782125, 'za', 'Prince Albert', 1, 'prince-albert'),
(452820, 782125, 'za', 'Murraysburg', 1, 'murraysburg'),
(452821, 782125, 'za', 'Mossel Bay', 1, 'mossel-bay'),
(452822, 782125, 'za', 'Montagu', 1, 'montagu'),
(452823, 782125, 'za', 'Laingsburg', 1, 'laingsburg'),
(452824, 782125, 'za', 'Ladismith', 1, 'ladismith'),
(452825, 782125, 'za', 'Hartenbos', 1, 'hartenbos'),
(452826, 782125, 'za', 'Glentana', 1, 'glentana'),
(452827, 782125, 'za', 'Calitzdorp', 1, 'calitzdorp'),
(452828, 782125, 'za', 'Bonnievale', 1, 'bonnievale'),
(452829, 782125, 'za', 'Barrydale', 1, 'barrydale'),
(452830, 782125, 'za', 'Ashton', 1, 'ashton'),
(452831, 782125, 'za', 'Albertina', 1, 'albertina'),
(452832, 782125, 'za', 'Yzerfontein', 1, 'yzerfontein'),
(452833, 782125, 'za', 'Wolseley', 1, 'wolseley'),
(452834, 782125, 'za', 'Wellington', 1, 'wellington'),
(452835, 782125, 'za', 'Vredenburg', 1, 'vredenburg'),
(452836, 782125, 'za', 'Villiersdorp', 1, 'villiersdorp'),
(452837, 782125, 'za', 'Velddrif', 1, 'velddrif'),
(452838, 782125, 'za', 'Vanrhynsdorp', 1, 'vanrhynsdorp'),
(452839, 782125, 'za', 'Tulbagh', 1, 'tulbagh'),
(452840, 782125, 'za', 'Strandfontein', 1, 'strandfontein'),
(452841, 782125, 'za', 'Strand', 1, 'strand'),
(452842, 782125, 'za', 'Robertson', 1, 'robertson'),
(452843, 782125, 'za', 'Pringle Bay', 1, 'pringle-bay'),
(452844, 782125, 'za', 'Prince Alfred Hamlet', 1, 'prince-alfred-hamlet'),
(452845, 782125, 'za', 'Porterville', 1, 'porterville'),
(452846, 782125, 'za', 'Piketberg', 1, 'piketberg'),
(452847, 782125, 'za', 'Paternoster', 1, 'paternoster'),
(452848, 782125, 'za', 'Parow', 1, 'parow'),
(452849, 782125, 'za', 'Paarl', 1, 'paarl'),
(452850, 782125, 'za', 'Noordhoek', 1, 'noordhoek'),
(452851, 782125, 'za', 'Napier', 1, 'napier'),
(452852, 782125, 'za', 'Muizenberg', 1, 'muizenberg'),
(452853, 782125, 'za', 'Moorreesburg', 1, 'moorreesburg'),
(452854, 782125, 'za', 'Mitchells Plain', 1, 'mitchells-plain'),
(452855, 782125, 'za', 'Milnerton', 1, 'milnerton'),
(452856, 782125, 'za', 'Melkbosstrand', 1, 'melkbosstrand'),
(452857, 782125, 'za', 'Lutzville', 1, 'lutzville'),
(452858, 782125, 'za', 'Langebaan', 1, 'langebaan'),
(452859, 782125, 'za', 'Kuilsrivier', 1, 'kuilsrivier'),
(452860, 782125, 'za', 'Kraaifontein', 1, 'kraaifontein'),
(452861, 782125, 'za', 'Kommetjie', 1, 'kommetjie'),
(452862, 782125, 'za', 'Houtbaai', 1, 'houtbaai'),
(452863, 782125, 'za', 'Hopefield', 1, 'hopefield'),
(452864, 782125, 'za', 'Greyton', 1, 'greyton'),
(452865, 782125, 'za', 'Graafwater', 1, 'graafwater'),
(452866, 782125, 'za', 'Goodwood', 1, 'goodwood'),
(452867, 782125, 'za', 'Genadendal', 1, 'genadendal'),
(452868, 782125, 'za', 'Gansbaai', 1, 'gansbaai'),
(452869, 782125, 'za', 'Franschhoek', 1, 'franschhoek'),
(452870, 782125, 'za', 'Eersterivier', 1, 'eersterivier'),
(452871, 782125, 'za', 'Durbanville', 1, 'durbanville'),
(452872, 782125, 'za', 'De Doorns', 1, 'de-doorns'),
(452873, 782125, 'za', 'Darling', 1, 'darling'),
(452874, 782125, 'za', 'Clanwilliam', 1, 'clanwilliam'),
(452875, 782125, 'za', 'Citrusdal', 1, 'citrusdal'),
(452876, 782125, 'za', 'Chatsworth', 1, 'chatsworth'),
(452877, 782125, 'za', 'Brackenfell', 1, 'brackenfell'),
(452878, 782125, 'za', 'Bitterfontein', 1, 'bitterfontein'),
(452879, 782125, 'za', 'Bellville', 1, 'bellville'),
(452880, 782125, 'za', 'Belhar', 1, 'belhar'),
(452881, 782125, 'za', 'Aurora', 1, 'aurora'),
(452882, 782125, 'za', 'Somerset West', 1, 'somerset-west'),
(452883, 782125, 'za', 'Rondebosch', 1, 'rondebosch'),
(452884, 782125, 'za', 'Bettys Bay', 1, 'bettys-bay'),
(452885, 782125, 'za', 'Blaauwberg', 1, 'blaauwberg'),
(452886, 782125, 'za', 'Blackheath', 1, 'blackheath'),
(452887, 782125, 'za', 'Blue Downs', 1, 'blue-downs'),
(452888, 782125, 'za', 'Boggomsbaai', 1, 'boggomsbaai'),
(452889, 782125, 'za', 'Cape Agulhas', 1, 'cape-agulhas'),
(452890, 782125, 'za', 'Cederberg', 1, 'cederberg'),
(452891, 782125, 'za', 'Elandsbay', 1, 'elandsbay'),
(452892, 782125, 'za', 'Elsies River', 1, 'elsies-river'),
(452893, 782125, 'za', 'Fish Hoek', 1, 'fish-hoek'),
(452894, 782125, 'za', 'Gordons Bay', 1, 'gordons-bay'),
(452895, 782125, 'za', 'Grassy Park', 1, 'grassy-park'),
(452896, 782125, 'za', 'Jacobs Bay', 1, 'jacobs-bay'),
(452897, 782125, 'za', 'Kleinmond', 1, 'kleinmond'),
(452898, 782125, 'za', 'Lamberts Bay', 1, 'lamberts-bay'),
(452899, 782125, 'za', 'Lansdowne', 1, 'lansdowne'),
(452900, 782125, 'za', 'Malmesbury', 1, 'malmesbury'),
(452901, 782125, 'za', 'Matroosfontein', 1, 'matroosfontein'),
(452902, 782125, 'za', 'Paarden Island', 1, 'paarden-island'),
(452903, 782125, 'za', 'Retreat', 1, 'retreat'),
(452904, 782125, 'za', 'Simons Town', 1, 'simons-town'),
(452905, 782125, 'za', 'St Helena Bay', 1, 'st-helena-bay'),
(452906, 782125, 'za', 'ZZ TBA', 1, 'zz-tba'),
(452907, 782125, 'za', 'Caledon', 1, 'caledon'),
(452908, 782125, 'za', 'Swellendam', 1, 'swellendam'),
(452909, 782125, 'za', 'Vredendal', 1, 'vredendal'),
(452910, 782125, 'za', 'Bredasdorp', 1, 'bredasdorp'),
(452911, 782125, 'za', 'Plettenberg Bay', 1, 'plettenberg-bay'),
(452912, 782125, 'za', 'Hermanus', 1, 'hermanus'),
(452913, 782125, 'za', 'Grabouw', 1, 'grabouw'),
(452914, 782125, 'za', 'Ceres', 1, 'ceres'),
(452915, 782125, 'za', 'Beaufort West', 1, 'beaufort-west'),
(452916, 782125, 'za', 'Atlantis', 1, 'atlantis'),
(452917, 782125, 'za', 'Knysna', 1, 'knysna'),
(452918, 782125, 'za', 'Saldanha', 1, 'saldanha'),
(452919, 782125, 'za', 'Oudtshoorn', 1, 'oudtshoorn'),
(452920, 782125, 'za', 'Stellenbosch', 1, 'stellenbosch'),
(452921, 782125, 'za', 'Worcester', 1, 'worcester'),
(452922, 782125, 'za', 'George', 1, 'george'),
(452923, 782125, 'za', 'Cape Town', 1, 'cape-town');

